---
title: "SAIF.Business.Claim stored procedures"
summary: "Oracle stored procedures and packages referenced by this library."
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-31
---

# SAIF.Business.Claim stored procedures

This page catalogs the 4 distinct Oracle stored procedures invoked by this library. The Legends CLI was queried individually for each of the 4 procedure names on 2026-08-31: `sp82286_statutoryweeklywage` returned its full PL/SQL source (schema `WCIS_DBA`) and is documented below with real parameters, business rules, and sample SQL. The other 3 — `sp82046_CalcAggRightDates`, `sp82067_TimelinessOf1stPayment`, `sp82289_medicallystationarydt` — were each queried by exact name and the CLI returned no source; their status is `not-found-by-cli`, not "retrieval unavailable." Because a proper retrieval attempt was made for these three and failed, their referencing .NET call sites are flagged as **possibly** dead code, pending further investigation — this is a hedge, not a definitive finding. `clsStatutoryWeeklyWageCalculation` (the caller of the one `found` procedure) is confirmed live code and carries no dead-code flag.

## Procedure catalog

| Package / Procedure | Schema | Type | Status | Purpose | Calling business objects |
| --- | --- | --- | --- | --- | --- |
| [`sp82286_statutoryweeklywage`](sp82286-statutoryweeklywage.md) | `WCIS_DBA` | Standalone procedure (with one nested private procedure) | **found** | Calculate the statutory weekly wage for a claim | `clsStatutoryWeeklyWageCalculation` |
| [`sp82046_CalcAggRightDates`](sp82046-calcaggrightdates.md) | Unknown — not returned by CLI | Unknown — presumed procedure from the BOF call site only | **not-found-by-cli** | Calculate aggravation-rights dates for a claim | `clsAggRightDates` |
| [`sp82067_TimelinessOf1stPayment`](sp82067-timelinessof1stpayment.md) | Unknown — not returned by CLI | Unknown — presumed procedure from the BOF call site only | **not-found-by-cli** | Evaluate timeliness of first payment for a claim | `clsTimelinessOfFirstPayment` |
| [`sp82289_medicallystationarydt`](sp82289-medicallystationarydt.md) | Unknown — not returned by CLI | Unknown — presumed procedure from the BOF call site only | **not-found-by-cli** | Retrieve the medically-stationary date for a claim | `clsMedicallyStationaryDate` |

**Note on the class-name discrepancy for `sp82067_TimelinessOf1stPayment`:** the source file is named `clsITimelinessOfFirstPayment.vb` (with an `I`), but the class it declares is `clsTimelinessOfFirstPayment` (no `I`). The class name above is correct; the file path in each page's `## Sources` retains the `I`.

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](../sql/index.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.Claim/clsAggRightDates.vb`
- `SAIF.Business.Claim/clsITimelinessOfFirstPayment.vb`
- `SAIF.Business.Claim/clsMedicallyStationaryDate.vb`
- `SAIF.Business.Claim/clsStatutoryWeeklyWageCalculation.vb`
- Retrieved via `legends oracle query --name sp82286_statutoryweeklywage` on 2026-08-31 (found); `legends oracle query --name sp82046_CalcAggRightDates`, `legends oracle query --name sp82067_TimelinessOf1stPayment`, and `legends oracle query --name sp82289_medicallystationarydt` on 2026-08-31 (not found by CLI)